<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.sql.*" %>
    <%@page import="com.DBtools"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<%@ include file="../bootstrap.jsp"%>
<title>教师个人资料</title>
<style>
.profile{
  width: 200px;
  height: 200px;
  display: flex;
  border:3px solid Gainsboro;
  border-radius: 50%;
  align-items: center;	
  justify-content: center;
  overflow: hidden;
}
.headimage {

width:100%;

height:200px;

border:1px solid #666;

overflow:hidden;

display:table-cell;

text-align:match-parent;

vertical-align:middle;}
</style>
<body>
<div class="container-fluid main">
<h1 align=center>教师个人资料</h1>
<hr>
<%
String UserNum=(String)request.getSession().getAttribute("UserNum");
System.out.println("教师号："+ UserNum);
ResultSet rs = new DBtools().query("select * from teacher where TeaId='"+UserNum+"'");
%>
          
<table class="table table-striped" width="80%" border="1" align="center">
<tr class="table-info">
	<th>教师编号</th>
	<th>名字</th>
	<th>性别</th>
	<th>邮箱</th>
	<th>年龄</th>
	<th>所在学院</th>
	<th width="70">操作</th>
</tr>
<%

while(rs.next()){
	String TeaId = rs.getString("TeaId");
%>
<tr>	
	<td><%=rs.getString("TeaId")%></td>
	<td><%=rs.getString("TeaName")%></td>
	<td><%=rs.getString("TeaGender")%></td>
	<td><%=rs.getString("TeaEmail")%></td>
	<td><%=rs.getString("TeaAge")%></td>
	<td><%=rs.getString("DepName")%></td>
	<td align="center"><a href="teacheredit.jsp?teacher=<%=TeaId%>">修改</a>
	
	
	
</tr>
<%}%>
</table>
<% 
rs.close();
%>
</div>
</body>
</html>